Search results 47

  2. Search results
  3. per year
Card image cap
NumberNumberNumber

Finds 3 numbers in a string by ignoring characters between them. ' example ...

Mar2
Card image cap
Grandchildren files and count

Returns list of files in 2 level folders Will not find files as children of ...

Jan11
Card image cap
CutString7

Cuts right part of a string starting from certain occurrence of a separator ...

Jan1
Card image cap
Macro keyboard shortcuts

Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...

2023Dec13
Card image cap
SQL Date from DateTime

Extract Date from Datetime field in SQL An old method I found in my archive.

2023Nov29
Card image cap
Latest records date and count

Find how many items in table, with column DateAdded is the latest DateAdded in ...

2023Nov2
Card image cap
BusinessDateDiff

Number of Business days between two dates. Note that it doesn't take Christmas, ...

2023Oct25
Card image cap
ANmaHTMLContent

Reads certain part in HTML output of a page. Will search for list of strings ...

2023Jul1
Card image cap
ANmaDate

Returns date in human format. Which is as follows... Just day name (and time) ...

2023Apr27
Card image cap
ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

2022Sep15
Card image cap
HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

2022Aug24
Card image cap
ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3